JHB_DPHRU_013 - Complete Data Profile

Dataset statistics

Number of variables	8
Number of observations	768
Missing cells	1758
Missing cells (%)	28.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	72.0 KiB
Average record size in memory	96.0 B

Variable types

Numeric	6
Unsupported	2

Alerts

`hdl_cholesterol_mmol_L_consolidated` is highly overall correlated with `total_cholesterol_mmol_L`	High correlation
`ldl_cholesterol_mmol_L_consolidated` is highly overall correlated with `total_cholesterol_mmol_L`	High correlation
`total_cholesterol_mmol_L` is highly overall correlated with `hdl_cholesterol_mmol_L_consolidated` and 1 other fields	High correlation
`Age (at enrolment)` has 14 (1.8%) missing values	Missing
`Sex` has 768 (100.0%) missing values	Missing
`study_week` has 768 (100.0%) missing values	Missing
`total_cholesterol_mmol_L` has 59 (7.7%) missing values	Missing
`hdl_cholesterol_mmol_L_consolidated` has 58 (7.6%) missing values	Missing
`ldl_cholesterol_mmol_L_consolidated` has 58 (7.6%) missing values	Missing
`fasting_glucose_mmol_L` has 32 (4.2%) missing values	Missing
`Sex` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`study_week` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2025-11-25 06:48:37.976976
Analysis finished	2025-11-25 06:48:39.616998
Duration	1.64 second
Software version	ydata-profiling vv4.18.0
Download configuration	config.json

Age (at enrolment)
Real number (ℝ)

Missing

Distinct	183
Distinct (%)	24.3%
Missing	14
Missing (%)	1.8%
Infinite	0
Infinite (%)	0.0%
Mean	33.533554

Minimum	18.1
Maximum	51
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.0 KiB

Quantile statistics

Minimum	18.1
5-th percentile	22
Q1	27.85
median	33.95
Q3	39
95-th percentile	46
Maximum	51
Range	32.9
Interquartile range (IQR)	11.15

Descriptive statistics

Standard deviation	7.3527855
Coefficient of variation (CV)	0.21926651
Kurtosis	-0.80768914
Mean	33.533554
Median Absolute Deviation (MAD)	5.95
Skewness	0.055500259
Sum	25284.3
Variance	54.063454
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	32	4.2%
34	31	4.0%
39	31	4.0%
37	29	3.8%
30	27	3.5%
31	25	3.3%
38	23	3.0%
41	22	2.9%
26	21	2.7%
35	21	2.7%
Other values (173)	492	64.1%

Value	Count	Frequency (%)
18.1	1	0.1%
18.8	1	0.1%
19	3	0.4%
19.3	1	0.1%
19.4	2	0.3%
19.5	1	0.1%
19.6	1	0.1%
20	9	1.2%
20.1	1	0.1%
20.6	1	0.1%

Value	Count	Frequency (%)
51	1	0.1%
50	3	0.4%
49.1	1	0.1%
49	5	0.7%
48	8	1.0%
47.9	1	0.1%
47.2	1	0.1%
47	10	1.3%
46.6	1	0.1%
46.4	1	0.1%

Sex
Unsupported

Missing Rejected Unsupported

Missing	768
Missing (%)	100.0%
Memory size	12.0 KiB

BMI (kg/m²)
Real number (ℝ)

Distinct	248
Distinct (%)	32.3%
Missing	1
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	27.852803

Minimum	15.1
Maximum	57
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.0 KiB

Quantile statistics

Minimum	15.1
5-th percentile	19.13
Q1	23
median	26.7
Q3	31.5
95-th percentile	40.54
Maximum	57
Range	41.9
Interquartile range (IQR)	8.5

Descriptive statistics

Standard deviation	6.6900116
Coefficient of variation (CV)	0.24019168
Kurtosis	1.6551874
Mean	27.852803
Median Absolute Deviation (MAD)	4.1
Skewness	1.0682353
Sum	21363.1
Variance	44.756255
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26.3	11	1.4%
25	10	1.3%
21.8	10	1.3%
26.7	9	1.2%
27.4	8	1.0%
25.8	8	1.0%
32.3	8	1.0%
21.5	8	1.0%
22.9	8	1.0%
28.9	7	0.9%
Other values (238)	680	88.5%

Value	Count	Frequency (%)
15.1	1	0.1%
15.3	1	0.1%
16	1	0.1%
16.1	1	0.1%
16.6	1	0.1%
16.8	1	0.1%
16.9	1	0.1%
17.1	1	0.1%
17.2	1	0.1%
17.3	1	0.1%

Value	Count	Frequency (%)
57	1	0.1%
56.1	1	0.1%
54.9	1	0.1%
54.3	1	0.1%
50.7	1	0.1%
50.4	1	0.1%
50.1	1	0.1%
49.8	3	0.4%
49	1	0.1%
46.4	2	0.3%

study_week
Unsupported

Missing Rejected Unsupported

Missing	768
Missing (%)	100.0%
Memory size	12.0 KiB

total_cholesterol_mmol_L
Real number (ℝ)

High correlation Missing

Distinct	331
Distinct (%)	46.7%
Missing	59
Missing (%)	7.7%
Infinite	0
Infinite (%)	0.0%
Mean	4.1249083

Minimum	1.12
Maximum	10.48
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.0 KiB

Quantile statistics

Minimum	1.12
5-th percentile	2.538
Q1	3.39
median	4
Q3	4.81
95-th percentile	6.016
Maximum	10.48
Range	9.36
Interquartile range (IQR)	1.42

Descriptive statistics

Standard deviation	1.1613229
Coefficient of variation (CV)	0.28153907
Kurtosis	3.3551237
Mean	4.1249083
Median Absolute Deviation (MAD)	0.7
Skewness	1.0133115
Sum	2924.56
Variance	1.3486708
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	10	1.3%
4.11	9	1.2%
3.62	7	0.9%
4.57	6	0.8%
3.89	6	0.8%
3.48	6	0.8%
4.93	6	0.8%
3.68	6	0.8%
2.77	5	0.7%
3.52	5	0.7%
Other values (321)	643	83.7%
(Missing)	59	7.7%

Value	Count	Frequency (%)
1.12	1	0.1%
1.22	1	0.1%
1.29	1	0.1%
1.38	1	0.1%
1.54	1	0.1%
1.59	1	0.1%
1.8	2	0.3%
1.85	1	0.1%
2.01	2	0.3%
2.06	1	0.1%

Value	Count	Frequency (%)
10.48	1	0.1%
10.29	1	0.1%
9.28	2	0.3%
9.04	1	0.1%
8.65	1	0.1%
7.7	1	0.1%
7.59	1	0.1%
7.3	1	0.1%
7.28	1	0.1%
6.82	1	0.1%

hdl_cholesterol_mmol_L_consolidated
Real number (ℝ)

High correlation Missing

Distinct	174
Distinct (%)	24.5%
Missing	58
Missing (%)	7.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.1211127

Minimum	0.28
Maximum	3.7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.0 KiB

Quantile statistics

Minimum	0.28
5-th percentile	0.51
Q1	0.83
median	1.07
Q3	1.37
95-th percentile	1.8855
Maximum	3.7
Range	3.42
Interquartile range (IQR)	0.54

Descriptive statistics

Standard deviation	0.44352229
Coefficient of variation (CV)	0.39560902
Kurtosis	4.4712255
Mean	1.1211127
Median Absolute Deviation (MAD)	0.26
Skewness	1.2913394
Sum	795.99
Variance	0.19671202
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.8	13	1.7%
1.04	13	1.7%
0.85	13	1.7%
0.93	13	1.7%
1.1	13	1.7%
1.18	11	1.4%
0.95	11	1.4%
1	10	1.3%
0.84	10	1.3%
0.87	9	1.2%
Other values (164)	594	77.3%
(Missing)	58	7.6%

Value	Count	Frequency (%)
0.28	1	0.1%
0.32	1	0.1%
0.33	2	0.3%
0.34	2	0.3%
0.35	1	0.1%
0.36	2	0.3%
0.37	2	0.3%
0.39	1	0.1%
0.4	2	0.3%
0.41	2	0.3%

Value	Count	Frequency (%)
3.7	3	0.4%
2.8	1	0.1%
2.53	2	0.3%
2.49	1	0.1%
2.44	1	0.1%
2.31	1	0.1%
2.3	1	0.1%
2.29	1	0.1%
2.24	2	0.3%
2.23	1	0.1%

ldl_cholesterol_mmol_L_consolidated
Real number (ℝ)

High correlation Missing

Distinct	261
Distinct (%)	36.8%
Missing	58
Missing (%)	7.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.6717042

Minimum	0
Maximum	6.04
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	12.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.6745
Q1	1.11
median	1.535
Q3	2.07
95-th percentile	3.18
Maximum	6.04
Range	6.04
Interquartile range (IQR)	0.96

Descriptive statistics

Standard deviation	0.77008108
Coefficient of variation (CV)	0.4606563
Kurtosis	1.8978142
Mean	1.6717042
Median Absolute Deviation (MAD)	0.475
Skewness	1.0866871
Sum	1186.91
Variance	0.59302488
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.01	9	1.2%
1.12	9	1.2%
1.32	9	1.2%
1.37	8	1.0%
1.29	8	1.0%
1.18	7	0.9%
2.06	7	0.9%
1.94	7	0.9%
1.26	7	0.9%
1.76	7	0.9%
Other values (251)	632	82.3%
(Missing)	58	7.6%

Value	Count	Frequency (%)
0	1	0.1%
0.33	1	0.1%
0.39	1	0.1%
0.42	2	0.3%
0.45	1	0.1%
0.46	1	0.1%
0.47	1	0.1%
0.5	3	0.4%
0.55	5	0.7%
0.56	4	0.5%

Value	Count	Frequency (%)
6.04	1	0.1%
4.41	1	0.1%
4.28	1	0.1%
4.25	2	0.3%
4.19	1	0.1%
4.13	1	0.1%
3.97	1	0.1%
3.94	1	0.1%
3.89	1	0.1%
3.87	1	0.1%

fasting_glucose_mmol_L
Real number (ℝ)

Missing

Distinct	276
Distinct (%)	37.5%
Missing	32
Missing (%)	4.2%
Infinite	0
Infinite (%)	0.0%
Mean	4.928356

Minimum	0.95
Maximum	15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.0 KiB

Quantile statistics

Minimum	0.95
5-th percentile	3.35
Q1	4.5
median	4.93
Q3	5.4125
95-th percentile	6.12
Maximum	15
Range	14.05
Interquartile range (IQR)	0.9125

Descriptive statistics

Standard deviation	0.95305831
Coefficient of variation (CV)	0.1933826
Kurtosis	19.566982
Mean	4.928356
Median Absolute Deviation (MAD)	0.45
Skewness	1.5235001
Sum	3627.27
Variance	0.90832015
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.21	9	1.2%
4.75	9	1.2%
5.42	8	1.0%
4.82	8	1.0%
4.93	8	1.0%
4.7	8	1.0%
5.24	8	1.0%
4.73	7	0.9%
4.57	7	0.9%
5.17	7	0.9%
Other values (266)	657	85.5%
(Missing)	32	4.2%

Value	Count	Frequency (%)
0.95	1	0.1%
1.12	1	0.1%
1.37	1	0.1%
1.47	1	0.1%
2.02	1	0.1%
2.04	1	0.1%
2.21	1	0.1%
2.22	1	0.1%
2.26	1	0.1%
2.55	2	0.3%

Value	Count	Frequency (%)
15	1	0.1%
9.91	1	0.1%
9.67	1	0.1%
8.24	1	0.1%
7.97	1	0.1%
7.62	1	0.1%
7.61	1	0.1%
7.42	1	0.1%
7.27	1	0.1%
7.06	1	0.1%

	Age (at enrolment)	BMI (kg/m²)	fasting_glucose_mmol_L	hdl_cholesterol_mmol_L_consolidated	ldl_cholesterol_mmol_L_consolidated	total_cholesterol_mmol_L
Age (at enrolment)	1.000	0.229	0.154	0.012	0.157	0.155
BMI (kg/m²)	0.229	1.000	0.116	0.020	0.106	0.096
fasting_glucose_mmol_L	0.154	0.116	1.000	0.008	0.032	-0.066
hdl_cholesterol_mmol_L_consolidated	0.012	0.020	0.008	1.000	0.269	0.507
ldl_cholesterol_mmol_L_consolidated	0.157	0.106	0.032	0.269	1.000	0.566
total_cholesterol_mmol_L	0.155	0.096	-0.066	0.507	0.566	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	Age (at enrolment)	Sex	BMI (kg/m²)	study_week	total_cholesterol_mmol_L	hdl_cholesterol_mmol_L_consolidated	ldl_cholesterol_mmol_L_consolidated	fasting_glucose_mmol_L
217	19.4	NaN	24.2	NaN	2.77	1.23	1.41	5.03
218	39.4	NaN	33.6	NaN	4.93	0.90	1.54	4.55
219	NaN	NaN	33.1	NaN	5.11	1.33	2.20	4.76
220	40.0	NaN	33.5	NaN	5.35	1.61	2.37	6.72
221	42.0	NaN	30.1	NaN	5.89	1.71	3.36	5.68
222	39.0	NaN	22.0	NaN	3.97	1.16	3.03	5.03
223	40.0	NaN	21.5	NaN	2.52	0.52	2.48	4.32
224	40.0	NaN	21.2	NaN	4.17	0.95	2.71	5.48
225	41.0	NaN	21.6	NaN	4.47	1.04	2.60	5.26
226	22.2	NaN	19.3	NaN	3.13	0.90	2.17	4.25

	Age (at enrolment)	Sex	BMI (kg/m²)	study_week	total_cholesterol_mmol_L	hdl_cholesterol_mmol_L_consolidated	ldl_cholesterol_mmol_L_consolidated	fasting_glucose_mmol_L
975	25.9	NaN	21.5	NaN	4.96	1.14	1.57	4.76
976	NaN	NaN	22.6	NaN	6.24	1.32	2.19	4.97
977	27.0	NaN	23.6	NaN	6.82	1.96	2.68	NaN
978	33.3	NaN	32.4	NaN	3.70	1.10	1.05	5.38
979	34.0	NaN	34.4	NaN	5.32	1.40	1.72	5.50
980	34.0	NaN	37.3	NaN	4.11	1.76	1.32	5.99
981	35.0	NaN	37.9	NaN	2.35	0.42	1.35	6.11
982	31.3	NaN	31.8	NaN	3.52	0.91	1.00	5.21
983	32.0	NaN	31.2	NaN	2.93	1.02	0.59	4.67
984	32.0	NaN	33.2	NaN	NaN	NaN	NaN	5.76

Overview

Interactions

Correlations

Missing values

Sample

Overview

Variables

Interactions

Correlations

Missing values

Sample